Before you can start using the Microsoft Excel add in power pivot.
You've got to activate it inside of your version of Microsoft Excel.
And this is really simple to do.
I'm going to walk you through just a couple of steps here and you'll get the power pivot tab inside
of your Excel ribbon.
So what we need to do is we're going to have up to our File tab.
We're going to go down into Options File two options.
Now inside the options window there's all sorts of features in here and I would highly recommend if
you don't spend much time in here to jump into the options window and see what's available to you.
Really it's a bunch of preferences you can set in regards to excel.
Now for the power pivot and in down the left hand side we're going to go to add ins now instead of my
copy of Excel that you have open in front of you.
I've already got the power pivot plug in activate it it's already there now for you it probably already
isn't active.
So what you're going to need to do is go down to the bottom of the Add-Ins window.
I'm going to change it from managed Excel add ins to manage comment add ins and I'm going to hit the
go button.
So this is going to open up an additional window where I get my card and ends.
And you want to make sure that you check the option for Microsoft Office power pivot for whatever version
you have.
2013 2010 2016 whatever it is.
Just make sure that that check mark is turned on once it's activated.
You can go ahead and hit OK.
Now you may need to close excel and reopen it.
Once you've done that you'll then get the power pivot tab on your ribbon.
So try this out for me open up Excel.
Go to the File tab.
Go down the options down the left hand side inside the options window.
Go to add ins and activate the COM add ins and set it there.
You'll activate the Excel power pivot add it again OK close Excel reopen and the power pivot tab should
be available for you.
Now we're going to jump in and see how we can work with data models within our power pivot environment
.
But first once again activate that and then you'll be good to go.